Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 475740 |
| Missing cells | 1427720 |
| Missing cells (%) | 15.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 189.6 MiB |
| Average record size in memory | 417.9 B |
Variable types
| Numeric | 13 |
|---|---|
| Categorical | 6 |
Series has constant value "EQ" | Constant |
Date has a high cardinality: 5306 distinct values | High cardinality |
Symbol has a high cardinality: 66 distinct values | High cardinality |
Prev Close is highly correlated with Open and 5 other fields | High correlation |
Open is highly correlated with Prev Close and 5 other fields | High correlation |
High is highly correlated with Prev Close and 5 other fields | High correlation |
Low is highly correlated with Prev Close and 5 other fields | High correlation |
Last is highly correlated with Prev Close and 5 other fields | High correlation |
Close is highly correlated with Prev Close and 5 other fields | High correlation |
VWAP is highly correlated with Prev Close and 5 other fields | High correlation |
Turnover is highly correlated with Trades and 1 other fields | High correlation |
Trades is highly correlated with Turnover and 1 other fields | High correlation |
Deliverable Volume is highly correlated with Turnover and 1 other fields | High correlation |
Prev Close is highly correlated with Open and 5 other fields | High correlation |
Open is highly correlated with Prev Close and 5 other fields | High correlation |
High is highly correlated with Prev Close and 5 other fields | High correlation |
Low is highly correlated with Prev Close and 5 other fields | High correlation |
Last is highly correlated with Prev Close and 5 other fields | High correlation |
Close is highly correlated with Prev Close and 5 other fields | High correlation |
VWAP is highly correlated with Prev Close and 5 other fields | High correlation |
Turnover is highly correlated with Deliverable Volume | High correlation |
Deliverable Volume is highly correlated with Turnover | High correlation |
Prev Close is highly correlated with Open and 5 other fields | High correlation |
Open is highly correlated with Prev Close and 5 other fields | High correlation |
High is highly correlated with Prev Close and 5 other fields | High correlation |
Low is highly correlated with Prev Close and 5 other fields | High correlation |
Last is highly correlated with Prev Close and 5 other fields | High correlation |
Close is highly correlated with Prev Close and 5 other fields | High correlation |
VWAP is highly correlated with Prev Close and 5 other fields | High correlation |
High is highly correlated with Close and 6 other fields | High correlation |
Deliverable Volume is highly correlated with Turnover and 1 other fields | High correlation |
df_index is highly correlated with Symbol | High correlation |
Trades is highly correlated with Turnover and 1 other fields | High correlation |
ISIN Code is highly correlated with Industry and 2 other fields | High correlation |
Close is highly correlated with High and 6 other fields | High correlation |
VWAP is highly correlated with High and 6 other fields | High correlation |
%Deliverble is highly correlated with Symbol | High correlation |
Low is highly correlated with High and 6 other fields | High correlation |
Industry is highly correlated with ISIN Code and 2 other fields | High correlation |
Company Name is highly correlated with ISIN Code and 2 other fields | High correlation |
Symbol is highly correlated with High and 11 other fields | High correlation |
Open is highly correlated with High and 6 other fields | High correlation |
Turnover is highly correlated with Deliverable Volume and 1 other fields | High correlation |
Prev Close is highly correlated with High and 6 other fields | High correlation |
Volume is highly correlated with Deliverable Volume and 1 other fields | High correlation |
Last is highly correlated with High and 6 other fields | High correlation |
Series is highly correlated with Company Name and 3 other fields | High correlation |
Company Name is highly correlated with Series and 3 other fields | High correlation |
Industry is highly correlated with Series and 3 other fields | High correlation |
Symbol is highly correlated with Series and 3 other fields | High correlation |
ISIN Code is highly correlated with Series and 3 other fields | High correlation |
Company Name has 475690 (> 99.9%) missing values | Missing |
Industry has 475690 (> 99.9%) missing values | Missing |
ISIN Code has 475690 (> 99.9%) missing values | Missing |
Company Name is uniformly distributed | Uniform |
ISIN Code is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2021-08-30 12:32:33.363041 |
|---|---|
| Analysis finished | 2021-08-30 12:35:22.082704 |
| Duration | 2 minutes and 48.72 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 235192 |
|---|---|
| Distinct (%) | 49.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59383.2172 |
| Minimum | 0 |
|---|---|
| Maximum | 235191 |
| Zeros | 52 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 465 |
| Q1 | 2331 |
| median | 5053 |
| Q3 | 116256.25 |
| 95-th percentile | 211404.05 |
| Maximum | 235191 |
| Range | 235191 |
| Interquartile range (IQR) | 113925.25 |
Descriptive statistics
| Standard deviation | 74787.62299 |
|---|---|
| Coefficient of variation (CV) | 1.259406723 |
| Kurtosis | -0.5627300011 |
| Mean | 59383.2172 |
| Median Absolute Deviation (MAD) | 4809 |
| Skewness | 0.9612231003 |
| Sum | 2.825097175 × 1010 |
| Variance | 5593188553 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 52 | < 0.1% |
| 21 | 52 | < 0.1% |
| 20 | 52 | < 0.1% |
| 44 | 52 | < 0.1% |
| 19 | 52 | < 0.1% |
| 45 | 52 | < 0.1% |
| 18 | 52 | < 0.1% |
| 46 | 52 | < 0.1% |
| 17 | 52 | < 0.1% |
| 47 | 52 | < 0.1% |
| Other values (235182) | 475220 |
| Value | Count | Frequency (%) |
| 0 | 52 | |
| 1 | 52 | |
| 2 | 52 | |
| 3 | 52 | |
| 4 | 52 | |
| 5 | 52 | |
| 6 | 52 | |
| 7 | 52 | |
| 8 | 52 | |
| 9 | 52 |
| Value | Count | Frequency (%) |
| 235191 | 1 | |
| 235190 | 1 | |
| 235189 | 1 | |
| 235188 | 1 | |
| 235187 | 1 | |
| 235186 | 1 | |
| 235185 | 1 | |
| 235184 | 1 | |
| 235183 | 1 | |
| 235182 | 1 |
| Distinct | 5306 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Memory size | 30.4 MiB |
| 2016-11-11 | 99 |
|---|---|
| 2011-01-31 | 99 |
| 2012-05-29 | 99 |
| 2015-11-17 | 99 |
| 2014-11-28 | 99 |
| Other values (5301) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 4756900 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2000-01-03 |
|---|---|
| 2nd row | 2000-01-04 |
| 3rd row | 2000-01-05 |
| 4th row | 2000-01-06 |
| 5th row | 2000-01-07 |
Common Values
| Value | Count | Frequency (%) |
| 2016-11-11 | 99 | < 0.1% |
| 2011-01-31 | 99 | < 0.1% |
| 2012-05-29 | 99 | < 0.1% |
| 2015-11-17 | 99 | < 0.1% |
| 2014-11-28 | 99 | < 0.1% |
| 2012-01-31 | 99 | < 0.1% |
| 2018-10-25 | 99 | < 0.1% |
| 2015-06-16 | 99 | < 0.1% |
| 2014-03-10 | 99 | < 0.1% |
| 2014-04-07 | 99 | < 0.1% |
| Other values (5296) | 474700 |
Length
| Value | Count | Frequency (%) |
| 2016-11-11 | 99 | < 0.1% |
| 2012-06-22 | 99 | < 0.1% |
| 2013-02-06 | 99 | < 0.1% |
| 2013-10-25 | 99 | < 0.1% |
| 2014-12-24 | 99 | < 0.1% |
| 2012-03-14 | 99 | < 0.1% |
| 2020-10-23 | 99 | < 0.1% |
| 2011-10-28 | 99 | < 0.1% |
| 2012-04-26 | 99 | < 0.1% |
| 2018-04-10 | 99 | < 0.1% |
| Other values (5296) | 474700 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1322344 | |
| - | 951380 | |
| 2 | 831406 | |
| 1 | 701967 | |
| 3 | 155567 | 3.3% |
| 7 | 135732 | 2.9% |
| 8 | 135101 | 2.8% |
| 9 | 132529 | 2.8% |
| 6 | 132070 | 2.8% |
| 5 | 130732 | 2.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 3805520 | |
| Dash Punctuation | 951380 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1322344 | |
| 2 | 831406 | |
| 1 | 701967 | |
| 3 | 155567 | 4.1% |
| 7 | 135732 | 3.6% |
| 8 | 135101 | 3.6% |
| 9 | 132529 | 3.5% |
| 6 | 132070 | 3.5% |
| 5 | 130732 | 3.4% |
| 4 | 128072 | 3.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 951380 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 4756900 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1322344 | |
| - | 951380 | |
| 2 | 831406 | |
| 1 | 701967 | |
| 3 | 155567 | 3.3% |
| 7 | 135732 | 2.9% |
| 8 | 135101 | 2.8% |
| 9 | 132529 | 2.8% |
| 6 | 132070 | 2.8% |
| 5 | 130732 | 2.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 4756900 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1322344 | |
| - | 951380 | |
| 2 | 831406 | |
| 1 | 701967 | |
| 3 | 155567 | 3.3% |
| 7 | 135732 | 2.9% |
| 8 | 135101 | 2.8% |
| 9 | 132529 | 2.8% |
| 6 | 132070 | 2.8% |
| 5 | 130732 | 2.7% |
| Distinct | 66 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.0 MiB |
| CIPLA | 10613 |
|---|---|
| IOC | 10613 |
| BPCL | 10613 |
| ICICIBANK | 10613 |
| RELIANCE | 10613 |
| Other values (61) |
Length
| Max length | 10 |
|---|---|
| Median length | 7 |
| Mean length | 6.873708328 |
| Min length | 2 |
Characters and Unicode
| Total characters | 3270098 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | ZEETELE |
|---|---|
| 2nd row | ZEETELE |
| 3rd row | ZEETELE |
| 4th row | ZEETELE |
| 5th row | ZEETELE |
Common Values
| Value | Count | Frequency (%) |
| CIPLA | 10613 | 2.2% |
| IOC | 10613 | 2.2% |
| BPCL | 10613 | 2.2% |
| ICICIBANK | 10613 | 2.2% |
| RELIANCE | 10613 | 2.2% |
| GRASIM | 10613 | 2.2% |
| WIPRO | 10613 | 2.2% |
| ITC | 10613 | 2.2% |
| HDFCBANK | 10613 | 2.2% |
| TITAN | 10613 | 2.2% |
| Other values (56) | 369610 |
Length
| Value | Count | Frequency (%) |
| hdfcbank | 10613 | 2.2% |
| icicibank | 10613 | 2.2% |
| reliance | 10613 | 2.2% |
| itc | 10613 | 2.2% |
| grasim | 10613 | 2.2% |
| m&m | 10613 | 2.2% |
| drreddy | 10613 | 2.2% |
| titan | 10613 | 2.2% |
| ioc | 10613 | 2.2% |
| ongc | 10613 | 2.2% |
| Other values (56) | 369610 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 356723 | 10.9% |
| I | 319358 | 9.8% |
| N | 258950 | 7.9% |
| T | 256672 | 7.8% |
| E | 235830 | 7.2% |
| C | 224719 | 6.9% |
| R | 180890 | 5.5% |
| O | 168123 | 5.1% |
| S | 160913 | 4.9% |
| L | 149536 | 4.6% |
| Other values (18) | 958384 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 3249242 | |
| Other Punctuation | 10613 | 0.3% |
| Dash Punctuation | 6405 | 0.2% |
| Decimal Number | 3838 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 356723 | 11.0% |
| I | 319358 | 9.8% |
| N | 258950 | 8.0% |
| T | 256672 | 7.9% |
| E | 235830 | 7.3% |
| C | 224719 | 6.9% |
| R | 180890 | 5.6% |
| O | 168123 | 5.2% |
| S | 160913 | 5.0% |
| L | 149536 | 4.6% |
| Other values (15) | 937528 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 6405 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 3838 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 10613 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 3249242 | |
| Common | 20856 | 0.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 356723 | 11.0% |
| I | 319358 | 9.8% |
| N | 258950 | 8.0% |
| T | 256672 | 7.9% |
| E | 235830 | 7.3% |
| C | 224719 | 6.9% |
| R | 180890 | 5.6% |
| O | 168123 | 5.2% |
| S | 160913 | 5.0% |
| L | 149536 | 4.6% |
| Other values (15) | 937528 |
Common
| Value | Count | Frequency (%) |
| & | 10613 | |
| - | 6405 | |
| 0 | 3838 | 18.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3270098 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 356723 | 10.9% |
| I | 319358 | 9.8% |
| N | 258950 | 7.9% |
| T | 256672 | 7.8% |
| E | 235830 | 7.2% |
| C | 224719 | 6.9% |
| R | 180890 | 5.5% |
| O | 168123 | 5.1% |
| S | 160913 | 4.9% |
| L | 149536 | 4.6% |
| Other values (18) | 958384 |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 26.8 MiB |
| EQ |
|---|
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 951480 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | EQ |
|---|---|
| 2nd row | EQ |
| 3rd row | EQ |
| 4th row | EQ |
| 5th row | EQ |
Common Values
| Value | Count | Frequency (%) |
| EQ | 475740 |
Length
Pie chart
| Value | Count | Frequency (%) |
| eq | 475740 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 475740 | |
| Q | 475740 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 951480 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 475740 | |
| Q | 475740 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 951480 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 475740 | |
| Q | 475740 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 951480 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 475740 | |
| Q | 475740 |
| Distinct | 63729 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1255.122428 |
| Minimum | 0 |
|---|---|
| Maximum | 32861.95 |
| Zeros | 2 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 97.25 |
| Q1 | 271.1 |
| median | 558.125 |
| Q3 | 1230.75 |
| 95-th percentile | 3944.8 |
| Maximum | 32861.95 |
| Range | 32861.95 |
| Interquartile range (IQR) | 959.65 |
Descriptive statistics
| Standard deviation | 2569.114743 |
|---|---|
| Coefficient of variation (CV) | 2.046903702 |
| Kurtosis | 49.37165031 |
| Mean | 1255.122428 |
| Median Absolute Deviation (MAD) | 363.175 |
| Skewness | 6.308670799 |
| Sum | 597049187.6 |
| Variance | 6600350.564 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 137 | 67 | < 0.1% |
| 140 | 63 | < 0.1% |
| 135 | 63 | < 0.1% |
| 200.15 | 61 | < 0.1% |
| 30 | 60 | < 0.1% |
| 125.2 | 60 | < 0.1% |
| 157.1 | 60 | < 0.1% |
| 270.05 | 59 | < 0.1% |
| 281 | 58 | < 0.1% |
| 112 | 58 | < 0.1% |
| Other values (63719) | 475081 |
| Value | Count | Frequency (%) |
| 0 | 2 | < 0.1% |
| 2 | 2 | < 0.1% |
| 9.15 | 2 | < 0.1% |
| 9.4 | 2 | < 0.1% |
| 9.5 | 2 | < 0.1% |
| 9.6 | 2 | < 0.1% |
| 9.65 | 12 | |
| 9.75 | 6 | |
| 9.8 | 4 | < 0.1% |
| 9.85 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 32861.95 | 2 | |
| 32766.1 | 2 | |
| 32661.85 | 2 | |
| 32617.75 | 2 | |
| 32498.6 | 2 | |
| 32443.5 | 2 | |
| 32403.95 | 2 | |
| 32371.05 | 2 | |
| 32233.4 | 2 | |
| 32226.4 | 2 |
| Distinct | 44298 |
|---|---|
| Distinct (%) | 9.3% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1256.67471 |
| Minimum | 8.5 |
|---|---|
| Maximum | 33399.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 8.5 |
|---|---|
| 5-th percentile | 97.4 |
| Q1 | 271.5 |
| median | 558.7 |
| Q3 | 1231.15 |
| 95-th percentile | 3950 |
| Maximum | 33399.95 |
| Range | 33391.45 |
| Interquartile range (IQR) | 959.65 |
Descriptive statistics
| Standard deviation | 2572.983975 |
|---|---|
| Coefficient of variation (CV) | 2.04745425 |
| Kurtosis | 49.42402029 |
| Mean | 1256.67471 |
| Median Absolute Deviation (MAD) | 363.4 |
| Skewness | 6.311702782 |
| Sum | 597787592.6 |
| Variance | 6620246.537 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 340 | 423 | 0.1% |
| 370 | 421 | 0.1% |
| 330 | 412 | 0.1% |
| 350 | 398 | 0.1% |
| 290 | 398 | 0.1% |
| 315 | 394 | 0.1% |
| 360 | 389 | 0.1% |
| 260 | 388 | 0.1% |
| 345 | 381 | 0.1% |
| 270 | 376 | 0.1% |
| Other values (44288) | 471710 |
| Value | Count | Frequency (%) |
| 8.5 | 2 | < 0.1% |
| 9.5 | 2 | < 0.1% |
| 9.6 | 2 | < 0.1% |
| 9.65 | 2 | < 0.1% |
| 9.75 | 8 | |
| 9.8 | 4 | |
| 9.85 | 8 | |
| 9.9 | 4 | |
| 9.95 | 4 | |
| 10 | 6 |
| Value | Count | Frequency (%) |
| 33399.95 | 2 | |
| 32800 | 2 | |
| 32698 | 2 | |
| 32599 | 2 | |
| 32500 | 4 | |
| 32499 | 2 | |
| 32489 | 2 | |
| 32480 | 2 | |
| 32451.5 | 2 | |
| 32301.2 | 2 |
| Distinct | 49036 |
|---|---|
| Distinct (%) | 10.3% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1275.34912 |
| Minimum | 9.75 |
|---|---|
| Maximum | 33480 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 9.75 |
|---|---|
| 5-th percentile | 99.4 |
| Q1 | 276 |
| median | 568.45 |
| Q3 | 1250 |
| 95-th percentile | 3999 |
| Maximum | 33480 |
| Range | 33470.25 |
| Interquartile range (IQR) | 974 |
Descriptive statistics
| Standard deviation | 2607.211411 |
|---|---|
| Coefficient of variation (CV) | 2.044311923 |
| Kurtosis | 49.21476336 |
| Mean | 1275.34912 |
| Median Absolute Deviation (MAD) | 369.15 |
| Skewness | 6.301985792 |
| Sum | 606670822.8 |
| Variance | 6797551.344 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 360 | 256 | 0.1% |
| 375 | 252 | 0.1% |
| 350 | 251 | 0.1% |
| 330 | 249 | 0.1% |
| 275 | 248 | 0.1% |
| 370 | 247 | 0.1% |
| 315 | 243 | 0.1% |
| 355 | 239 | 0.1% |
| 280 | 239 | 0.1% |
| 305 | 234 | < 0.1% |
| Other values (49026) | 473232 |
| Value | Count | Frequency (%) |
| 9.75 | 2 | < 0.1% |
| 9.8 | 8 | |
| 9.85 | 4 | |
| 9.9 | 6 | |
| 9.95 | 2 | < 0.1% |
| 10 | 8 | |
| 10.1 | 4 | |
| 10.15 | 4 | |
| 10.2 | 2 | < 0.1% |
| 10.25 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 33480 | 2 | |
| 33328.8 | 2 | |
| 32916.85 | 2 | |
| 32799.2 | 2 | |
| 32766.6 | 2 | |
| 32750 | 2 | |
| 32698.95 | 2 | |
| 32644.95 | 2 | |
| 32604.25 | 2 | |
| 32549 | 2 |
| Distinct | 51335 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1236.558405 |
| Minimum | 8.5 |
|---|---|
| Maximum | 32468.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 8.5 |
|---|---|
| 5-th percentile | 95.25 |
| Q1 | 266.25 |
| median | 549 |
| Q3 | 1210.25 |
| 95-th percentile | 3891.05 |
| Maximum | 32468.1 |
| Range | 32459.6 |
| Interquartile range (IQR) | 944 |
Descriptive statistics
| Standard deviation | 2534.53152 |
|---|---|
| Coefficient of variation (CV) | 2.049665838 |
| Kurtosis | 49.53362423 |
| Mean | 1236.558405 |
| Median Absolute Deviation (MAD) | 357.35 |
| Skewness | 6.315493272 |
| Sum | 588218467.9 |
| Variance | 6423850.027 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300 | 274 | 0.1% |
| 325 | 263 | 0.1% |
| 370 | 252 | 0.1% |
| 320 | 251 | 0.1% |
| 310 | 244 | 0.1% |
| 390 | 240 | 0.1% |
| 350 | 239 | 0.1% |
| 305 | 230 | < 0.1% |
| 260 | 228 | < 0.1% |
| 330 | 225 | < 0.1% |
| Other values (51325) | 473244 |
| Value | Count | Frequency (%) |
| 8.5 | 2 | < 0.1% |
| 8.95 | 2 | < 0.1% |
| 9.1 | 2 | < 0.1% |
| 9.15 | 2 | < 0.1% |
| 9.3 | 2 | < 0.1% |
| 9.5 | 2 | < 0.1% |
| 9.55 | 6 | |
| 9.6 | 6 | |
| 9.65 | 6 | |
| 9.7 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 32468.1 | 2 | |
| 32400 | 2 | |
| 32301 | 2 | |
| 32300.05 | 2 | |
| 32300 | 2 | |
| 32290 | 2 | |
| 32200 | 2 | |
| 32136.85 | 2 | |
| 32082.25 | 2 | |
| 31850 | 2 |
| Distinct | 48570 |
|---|---|
| Distinct (%) | 10.2% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1255.309781 |
| Minimum | 9.1 |
|---|---|
| Maximum | 32849 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 9.1 |
|---|---|
| 5-th percentile | 97.25 |
| Q1 | 271.2 |
| median | 558 |
| Q3 | 1231 |
| 95-th percentile | 3945 |
| Maximum | 32849 |
| Range | 32839.9 |
| Interquartile range (IQR) | 959.8 |
Descriptive statistics
| Standard deviation | 2569.138277 |
|---|---|
| Coefficient of variation (CV) | 2.046616952 |
| Kurtosis | 49.356176 |
| Mean | 1255.309781 |
| Median Absolute Deviation (MAD) | 363 |
| Skewness | 6.307437085 |
| Sum | 597138309.7 |
| Variance | 6600471.489 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 400 | 258 | 0.1% |
| 330 | 255 | 0.1% |
| 380 | 254 | 0.1% |
| 350 | 253 | 0.1% |
| 340 | 249 | 0.1% |
| 325 | 241 | 0.1% |
| 345 | 241 | 0.1% |
| 315 | 238 | 0.1% |
| 300 | 233 | < 0.1% |
| 310 | 229 | < 0.1% |
| Other values (48560) | 473239 |
| Value | Count | Frequency (%) |
| 9.1 | 2 | < 0.1% |
| 9.25 | 2 | < 0.1% |
| 9.5 | 2 | < 0.1% |
| 9.6 | 8 | |
| 9.65 | 2 | < 0.1% |
| 9.7 | 4 | |
| 9.75 | 2 | < 0.1% |
| 9.8 | 4 | |
| 9.85 | 4 | |
| 9.9 | 4 |
| Value | Count | Frequency (%) |
| 32849 | 2 | |
| 32760 | 2 | |
| 32600 | 2 | |
| 32598 | 2 | |
| 32520 | 2 | |
| 32450 | 2 | |
| 32430 | 2 | |
| 32420 | 2 | |
| 32208.55 | 2 | |
| 32184 | 2 |
| Distinct | 63739 |
|---|---|
| Distinct (%) | 13.4% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1255.47453 |
| Minimum | 9.15 |
|---|---|
| Maximum | 32861.95 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 9.15 |
|---|---|
| 5-th percentile | 97.3 |
| Q1 | 271.15 |
| median | 558.3 |
| Q3 | 1230.95 |
| 95-th percentile | 3945.35 |
| Maximum | 32861.95 |
| Range | 32852.8 |
| Interquartile range (IQR) | 959.8 |
Descriptive statistics
| Standard deviation | 2569.882386 |
|---|---|
| Coefficient of variation (CV) | 2.046941077 |
| Kurtosis | 49.35739553 |
| Mean | 1255.47453 |
| Median Absolute Deviation (MAD) | 363.3 |
| Skewness | 6.307921552 |
| Sum | 597216679 |
| Variance | 6604295.476 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 137 | 67 | < 0.1% |
| 135 | 63 | < 0.1% |
| 140 | 63 | < 0.1% |
| 200.15 | 61 | < 0.1% |
| 125.2 | 60 | < 0.1% |
| 30 | 60 | < 0.1% |
| 157.1 | 60 | < 0.1% |
| 270.05 | 59 | < 0.1% |
| 159.85 | 58 | < 0.1% |
| 112 | 58 | < 0.1% |
| Other values (63729) | 475081 |
| Value | Count | Frequency (%) |
| 9.15 | 2 | < 0.1% |
| 9.4 | 2 | < 0.1% |
| 9.5 | 2 | < 0.1% |
| 9.6 | 2 | < 0.1% |
| 9.65 | 12 | |
| 9.75 | 6 | |
| 9.8 | 4 | < 0.1% |
| 9.85 | 4 | < 0.1% |
| 9.95 | 4 | < 0.1% |
| 10 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 32861.95 | 2 | |
| 32766.1 | 2 | |
| 32661.85 | 2 | |
| 32617.75 | 2 | |
| 32498.6 | 2 | |
| 32443.5 | 2 | |
| 32403.95 | 2 | |
| 32371.05 | 2 | |
| 32233.4 | 2 | |
| 32226.4 | 2 |
| Distinct | 138831 |
|---|---|
| Distinct (%) | 29.2% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1256.050425 |
| Minimum | 9.21 |
|---|---|
| Maximum | 32975.24 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 9.21 |
|---|---|
| 5-th percentile | 97.4645 |
| Q1 | 271.34 |
| median | 558.4 |
| Q3 | 1231.17 |
| 95-th percentile | 3946.8 |
| Maximum | 32975.24 |
| Range | 32966.03 |
| Interquartile range (IQR) | 959.83 |
Descriptive statistics
| Standard deviation | 2570.439218 |
|---|---|
| Coefficient of variation (CV) | 2.046445881 |
| Kurtosis | 49.35536364 |
| Mean | 1256.050425 |
| Median Absolute Deviation (MAD) | 363.305 |
| Skewness | 6.307368685 |
| Sum | 597490626.6 |
| Variance | 6607157.771 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 136.49 | 25 | < 0.1% |
| 277.76 | 24 | < 0.1% |
| 137.07 | 24 | < 0.1% |
| 300.4 | 23 | < 0.1% |
| 259.75 | 23 | < 0.1% |
| 135.35 | 22 | < 0.1% |
| 141.82 | 22 | < 0.1% |
| 186.97 | 22 | < 0.1% |
| 163.02 | 21 | < 0.1% |
| 168.06 | 21 | < 0.1% |
| Other values (138821) | 475463 | |
| (Missing) | 50 | < 0.1% |
| Value | Count | Frequency (%) |
| 9.21 | 2 | < 0.1% |
| 9.45 | 2 | < 0.1% |
| 9.61 | 2 | < 0.1% |
| 9.62 | 2 | < 0.1% |
| 9.65 | 2 | < 0.1% |
| 9.66 | 2 | < 0.1% |
| 9.68 | 6 | |
| 9.72 | 2 | < 0.1% |
| 9.75 | 2 | < 0.1% |
| 9.76 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 32975.24 | 2 | |
| 32882.47 | 2 | |
| 32599.8 | 2 | |
| 32581.18 | 2 | |
| 32556.12 | 2 | |
| 32540.7 | 2 | |
| 32458.75 | 2 | |
| 32437.36 | 2 | |
| 32393.75 | 2 | |
| 32304.71 | 2 |
| Distinct | 220434 |
|---|---|
| Distinct (%) | 46.3% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3065752.612 |
| Minimum | 3 |
|---|---|
| Maximum | 481058927 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 10586 |
| Q1 | 224287 |
| median | 1026758 |
| Q3 | 3038475 |
| 95-th percentile | 12158159 |
| Maximum | 481058927 |
| Range | 481058924 |
| Interquartile range (IQR) | 2814188 |
Descriptive statistics
| Standard deviation | 7349109.321 |
|---|---|
| Coefficient of variation (CV) | 2.397163194 |
| Kurtosis | 366.0976462 |
| Mean | 3065752.612 |
| Median Absolute Deviation (MAD) | 952379 |
| Skewness | 12.35294776 |
| Sum | 1.45834786 × 1012 |
| Variance | 5.400940781 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 62 | < 0.1% |
| 200 | 48 | < 0.1% |
| 1000 | 42 | < 0.1% |
| 500 | 36 | < 0.1% |
| 300 | 34 | < 0.1% |
| 700 | 34 | < 0.1% |
| 900 | 32 | < 0.1% |
| 1400 | 28 | < 0.1% |
| 800 | 28 | < 0.1% |
| 400 | 28 | < 0.1% |
| Other values (220424) | 475318 | |
| (Missing) | 50 | < 0.1% |
| Value | Count | Frequency (%) |
| 3 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| 25 | 4 | |
| 27 | 4 | |
| 32 | 2 | < 0.1% |
| 33 | 2 | < 0.1% |
| 35 | 2 | < 0.1% |
| 50 | 8 | |
| 51 | 4 |
| Value | Count | Frequency (%) |
| 481058927 | 2 | |
| 479716245 | 2 | |
| 390577839 | 2 | |
| 316008609 | 2 | |
| 286857658 | 2 | |
| 286173629 | 2 | |
| 283614463 | 2 | |
| 270968028 | 2 | |
| 265709391 | 2 | |
| 262677081 | 2 |
| Distinct | 236251 |
|---|---|
| Distinct (%) | 49.7% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.606111268 × 1014 |
| Minimum | 10470000 |
|---|---|
| Maximum | 3.564334168 × 1016 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 10470000 |
|---|---|
| 5-th percentile | 3.7745247 × 1011 |
| Q1 | 1.632697149 × 1013 |
| median | 6.802326423 × 1013 |
| Q3 | 1.856753031 × 1014 |
| 95-th percentile | 5.88649934 × 1014 |
| Maximum | 3.564334168 × 1016 |
| Range | 3.564334167 × 1016 |
| Interquartile range (IQR) | 1.693483316 × 1014 |
Descriptive statistics
| Standard deviation | 3.288006109 × 1014 |
|---|---|
| Coefficient of variation (CV) | 2.04718451 |
| Kurtosis | 912.6613985 |
| Mean | 1.606111268 × 1014 |
| Median Absolute Deviation (MAD) | 6.204383775 × 1013 |
| Skewness | 16.14879937 |
| Sum | 7.640110689 × 1019 |
| Variance | 1.081098417 × 1029 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.291994716 × 1013 | 5 | < 0.1% |
| 260000000 | 4 | < 0.1% |
| 297500000 | 4 | < 0.1% |
| 4527840000 | 4 | < 0.1% |
| 275000000 | 4 | < 0.1% |
| 1535000000 | 4 | < 0.1% |
| 1.8760005 × 1011 | 4 | < 0.1% |
| 280000000 | 4 | < 0.1% |
| 1.665872142 × 1013 | 3 | < 0.1% |
| 3.413466802 × 1014 | 3 | < 0.1% |
| Other values (236241) | 475651 | |
| (Missing) | 50 | < 0.1% |
| Value | Count | Frequency (%) |
| 10470000 | 2 | |
| 25700000 | 2 | |
| 27900000 | 2 | |
| 63000000 | 2 | |
| 88450000 | 2 | |
| 95950000 | 2 | |
| 97500000 | 2 | |
| 156300000 | 2 | |
| 177500000 | 2 | |
| 179500000 | 2 |
| Value | Count | Frequency (%) |
| 3.564334168 × 1016 | 2 | |
| 2.481773122 × 1016 | 2 | |
| 1.570039582 × 1016 | 2 | |
| 1.498221906 × 1016 | 2 | |
| 1.473433631 × 1016 | 2 | |
| 1.461958918 × 1016 | 2 | |
| 1.426399959 × 1016 | 2 | |
| 1.268361556 × 1016 | 2 | |
| 1.236079553 × 1016 | 2 | |
| 1.184668763 × 1016 | 2 |
| Distinct | 79162 |
|---|---|
| Distinct (%) | 16.6% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 62980.19751 |
| Minimum | 11 |
|---|---|
| Maximum | 1643015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 7411 |
| Q1 | 37069.25 |
| median | 61964.27098 |
| Q3 | 65386 |
| 95-th percentile | 145230.6409 |
| Maximum | 1643015 |
| Range | 1643004 |
| Interquartile range (IQR) | 28316.75 |
Descriptive statistics
| Standard deviation | 52112.14655 |
|---|---|
| Coefficient of variation (CV) | 0.8274370137 |
| Kurtosis | 56.68163002 |
| Mean | 62980.19751 |
| Median Absolute Deviation (MAD) | 19592.27098 |
| Skewness | 4.9989478 |
| Sum | 2.995905015 × 1010 |
| Variance | 2715675818 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 61964.27098 | 114848 | 24.1% |
| 62645.70928 | 5700 | 1.2% |
| 138367.6274 | 2850 | 0.6% |
| 82923.62541 | 2850 | 0.6% |
| 111849.0301 | 2850 | 0.6% |
| 37121.1873 | 2850 | 0.6% |
| 78354.90879 | 2850 | 0.6% |
| 120602.2317 | 2850 | 0.6% |
| 150702.7675 | 2850 | 0.6% |
| 55511.07003 | 2850 | 0.6% |
| Other values (79152) | 332342 |
| Value | Count | Frequency (%) |
| 11 | 2 | |
| 16 | 2 | |
| 18 | 2 | |
| 20 | 2 | |
| 21 | 2 | |
| 24 | 2 | |
| 26 | 2 | |
| 27 | 2 | |
| 28 | 4 | |
| 30 | 2 |
| Value | Count | Frequency (%) |
| 1643015 | 2 | |
| 1428490 | 2 | |
| 1424793 | 2 | |
| 1318669 | 2 | |
| 1303825 | 2 | |
| 1285533 | 2 | |
| 1233053 | 2 | |
| 1205984 | 2 | |
| 1201928 | 2 | |
| 1194059 | 2 |
| Distinct | 200001 |
|---|---|
| Distinct (%) | 42.0% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1319019.123 |
| Minimum | 5 |
|---|---|
| Maximum | 232530747 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 9831 |
| Q1 | 143455 |
| median | 570927 |
| Q3 | 1426126 |
| 95-th percentile | 4945056 |
| Maximum | 232530747 |
| Range | 232530742 |
| Interquartile range (IQR) | 1282671 |
Descriptive statistics
| Standard deviation | 2733060.883 |
|---|---|
| Coefficient of variation (CV) | 2.072040379 |
| Kurtosis | 987.5542677 |
| Mean | 1319019.123 |
| Median Absolute Deviation (MAD) | 514847 |
| Skewness | 19.09900594 |
| Sum | 6.274442065 × 1011 |
| Variance | 7.46962179 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1315098.408 | 16077 | 3.4% |
| 1415717.628 | 1038 | 0.2% |
| 999465.3974 | 528 | 0.1% |
| 2551708.554 | 525 | 0.1% |
| 4183406.037 | 517 | 0.1% |
| 1331770.503 | 515 | 0.1% |
| 4571757.617 | 514 | 0.1% |
| 440876.3015 | 514 | 0.1% |
| 1550749.808 | 514 | 0.1% |
| 2280885.189 | 514 | 0.1% |
| Other values (199991) | 454434 |
| Value | Count | Frequency (%) |
| 5 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 17 | 2 | < 0.1% |
| 25 | 6 | |
| 30 | 2 | < 0.1% |
| 32 | 2 | < 0.1% |
| 50 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 57 | 2 | < 0.1% |
| 58 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 232530747 | 2 | |
| 216377820 | 2 | |
| 187584905 | 2 | |
| 185656354 | 2 | |
| 181390171 | 2 | |
| 170946275 | 2 | |
| 148313109 | 2 | |
| 139943805 | 2 | |
| 139345365 | 2 | |
| 135572090 | 2 |
| Distinct | 9638 |
|---|---|
| Distinct (%) | 2.0% |
| Missing | 50 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5022203801 |
| Minimum | 0.0236 |
|---|---|
| Maximum | 1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 3.6 MiB |
Quantile statistics
| Minimum | 0.0236 |
|---|---|
| 5-th percentile | 0.1863 |
| Q1 | 0.3728 |
| median | 0.5029968487 |
| Q3 | 0.6294 |
| 95-th percentile | 0.8029 |
| Maximum | 1 |
| Range | 0.9764 |
| Interquartile range (IQR) | 0.2566 |
Descriptive statistics
| Standard deviation | 0.184320399 |
|---|---|
| Coefficient of variation (CV) | 0.3670109902 |
| Kurtosis | -0.3812012965 |
| Mean | 0.5022203801 |
| Median Absolute Deviation (MAD) | 0.1280968487 |
| Skewness | -0.02155004166 |
| Sum | 238901.2126 |
| Variance | 0.03397400948 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.5029968487 | 16077 | 3.4% |
| 0.4522112597 | 1038 | 0.2% |
| 0.5562428213 | 528 | 0.1% |
| 0.4340255386 | 525 | 0.1% |
| 0.4734629777 | 517 | 0.1% |
| 0.6031712795 | 515 | 0.1% |
| 0.4350394407 | 514 | 0.1% |
| 0.591634328 | 514 | 0.1% |
| 0.5092087855 | 514 | 0.1% |
| 0.3679444491 | 514 | 0.1% |
| Other values (9628) | 454434 |
| Value | Count | Frequency (%) |
| 0.0236 | 2 | |
| 0.0279 | 2 | |
| 0.0283 | 2 | |
| 0.0294 | 2 | |
| 0.0299 | 4 | |
| 0.0318 | 2 | |
| 0.0326 | 2 | |
| 0.0328 | 2 | |
| 0.0343 | 4 | |
| 0.0358 | 2 |
| Value | Count | Frequency (%) |
| 1 | 189 | |
| 0.9998 | 2 | < 0.1% |
| 0.9997 | 4 | < 0.1% |
| 0.9996 | 10 | < 0.1% |
| 0.9995 | 6 | < 0.1% |
| 0.9993 | 2 | < 0.1% |
| 0.9992 | 6 | < 0.1% |
| 0.999 | 1 | < 0.1% |
| 0.999 | 1 | < 0.1% |
| 0.9989 | 2 | < 0.1% |
| Distinct | 50 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 475690 |
| Missing (%) | > 99.9% |
| Memory size | 14.5 MiB |
| Larsen & Toubro Ltd. | 1 |
|---|---|
| NTPC Ltd. | 1 |
| Indian Oil Corporation Ltd. | 1 |
| Bharti Airtel Ltd. | 1 |
| UltraTech Cement Ltd. | 1 |
| Other values (45) |
Length
| Max length | 44 |
|---|---|
| Median length | 18 |
| Mean length | 20.66 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1033 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 50 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Adani Ports and Special Economic Zone Ltd. |
|---|---|
| 2nd row | Asian Paints Ltd. |
| 3rd row | Axis Bank Ltd. |
| 4th row | Bajaj Auto Ltd. |
| 5th row | Bajaj Finserv Ltd. |
Common Values
| Value | Count | Frequency (%) |
| Larsen & Toubro Ltd. | 1 | < 0.1% |
| NTPC Ltd. | 1 | < 0.1% |
| Indian Oil Corporation Ltd. | 1 | < 0.1% |
| Bharti Airtel Ltd. | 1 | < 0.1% |
| UltraTech Cement Ltd. | 1 | < 0.1% |
| HDFC Bank Ltd. | 1 | < 0.1% |
| Nestle India Ltd. | 1 | < 0.1% |
| Kotak Mahindra Bank Ltd. | 1 | < 0.1% |
| IndusInd Bank Ltd. | 1 | < 0.1% |
| Coal India Ltd. | 1 | < 0.1% |
| Other values (40) | 40 | < 0.1% |
| (Missing) | 475690 |
Length
| Value | Count | Frequency (%) |
| ltd | 49 | |
| india | 6 | 3.6% |
| bank | 6 | 3.6% |
| corporation | 5 | 3.0% |
| industries | 5 | 3.0% |
| mahindra | 4 | 2.4% |
| 3 | 1.8% | |
| bajaj | 3 | 1.8% |
| tata | 3 | 1.8% |
| bharti | 2 | 1.2% |
| Other values (74) | 80 |
Most occurring characters
| Value | Count | Frequency (%) |
| 116 | 11.2% | |
| t | 97 | 9.4% |
| a | 77 | 7.5% |
| d | 75 | 7.3% |
| n | 66 | 6.4% |
| i | 56 | 5.4% |
| e | 54 | 5.2% |
| L | 54 | 5.2% |
| r | 52 | 5.0% |
| . | 50 | 4.8% |
| Other values (44) | 336 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 677 | |
| Uppercase Letter | 184 | 17.8% |
| Space Separator | 116 | 11.2% |
| Other Punctuation | 54 | 5.2% |
| Open Punctuation | 1 | 0.1% |
| Close Punctuation | 1 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 97 | |
| a | 77 | |
| d | 75 | |
| n | 66 | |
| i | 56 | |
| e | 54 | |
| r | 52 | |
| o | 47 | |
| s | 33 | 4.9% |
| l | 20 | 3.0% |
| Other values (15) | 100 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 54 | |
| I | 21 | 11.4% |
| C | 18 | 9.8% |
| B | 13 | 7.1% |
| T | 10 | 5.4% |
| S | 9 | 4.9% |
| M | 8 | 4.3% |
| P | 7 | 3.8% |
| A | 6 | 3.3% |
| H | 6 | 3.3% |
| Other values (13) | 32 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 50 | |
| & | 3 | 5.6% |
| ' | 1 | 1.9% |
Space Separator
| Value | Count | Frequency (%) |
| 116 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 861 | |
| Common | 172 | 16.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 97 | 11.3% |
| a | 77 | 8.9% |
| d | 75 | 8.7% |
| n | 66 | 7.7% |
| i | 56 | 6.5% |
| e | 54 | 6.3% |
| L | 54 | 6.3% |
| r | 52 | 6.0% |
| o | 47 | 5.5% |
| s | 33 | 3.8% |
| Other values (38) | 250 |
Common
| Value | Count | Frequency (%) |
| 116 | ||
| . | 50 | |
| & | 3 | 1.7% |
| ' | 1 | 0.6% |
| ( | 1 | 0.6% |
| ) | 1 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1033 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 116 | 11.2% | |
| t | 97 | 9.4% |
| a | 77 | 7.5% |
| d | 75 | 7.3% |
| n | 66 | 6.4% |
| i | 56 | 5.4% |
| e | 54 | 5.2% |
| L | 54 | 5.2% |
| r | 52 | 5.0% |
| . | 50 | 4.8% |
| Other values (44) | 336 |
| Distinct | 13 |
|---|---|
| Distinct (%) | 26.0% |
| Missing | 475690 |
| Missing (%) | > 99.9% |
| Memory size | 14.5 MiB |
| FINANCIAL SERVICES | |
|---|---|
| ENERGY | |
| CONSUMER GOODS | |
| AUTOMOBILE | |
| METALS | |
| Other values (8) |
Length
| Max length | 24 |
|---|---|
| Median length | 10 |
| Mean length | 11.14 |
| Min length | 2 |
Characters and Unicode
| Total characters | 557 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 8.0% |
Sample
| 1st row | SERVICES |
|---|---|
| 2nd row | CONSUMER GOODS |
| 3rd row | FINANCIAL SERVICES |
| 4th row | AUTOMOBILE |
| 5th row | FINANCIAL SERVICES |
Common Values
| Value | Count | Frequency (%) |
| FINANCIAL SERVICES | 9 | < 0.1% |
| ENERGY | 7 | < 0.1% |
| CONSUMER GOODS | 6 | < 0.1% |
| AUTOMOBILE | 6 | < 0.1% |
| METALS | 5 | < 0.1% |
| IT | 5 | < 0.1% |
| CEMENT & CEMENT PRODUCTS | 3 | < 0.1% |
| PHARMA | 3 | < 0.1% |
| TELECOM | 2 | < 0.1% |
| SERVICES | 1 | < 0.1% |
| Other values (3) | 3 | < 0.1% |
| (Missing) | 475690 |
Length
| Value | Count | Frequency (%) |
| services | 10 | |
| financial | 9 | |
| energy | 7 | |
| goods | 6 | |
| consumer | 6 | |
| automobile | 6 | |
| cement | 6 | |
| metals | 5 | 6.4% |
| it | 5 | 6.4% |
| 5 | 6.4% | |
| Other values (8) | 13 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 75 | |
| I | 46 | 8.3% |
| S | 45 | 8.1% |
| N | 42 | 7.5% |
| C | 39 | 7.0% |
| O | 37 | 6.6% |
| A | 37 | 6.6% |
| T | 34 | 6.1% |
| R | 33 | 5.9% |
| M | 30 | 5.4% |
| Other values (12) | 139 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 524 | |
| Space Separator | 28 | 5.0% |
| Other Punctuation | 5 | 0.9% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 75 | |
| I | 46 | |
| S | 45 | |
| N | 42 | 8.0% |
| C | 39 | 7.4% |
| O | 37 | 7.1% |
| A | 37 | 7.1% |
| T | 34 | 6.5% |
| R | 33 | 6.3% |
| M | 30 | 5.7% |
| Other values (10) | 106 |
Space Separator
| Value | Count | Frequency (%) |
| 28 |
Other Punctuation
| Value | Count | Frequency (%) |
| & | 5 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 524 | |
| Common | 33 | 5.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 75 | |
| I | 46 | |
| S | 45 | |
| N | 42 | 8.0% |
| C | 39 | 7.4% |
| O | 37 | 7.1% |
| A | 37 | 7.1% |
| T | 34 | 6.5% |
| R | 33 | 6.3% |
| M | 30 | 5.7% |
| Other values (10) | 106 |
Common
| Value | Count | Frequency (%) |
| 28 | ||
| & | 5 | 15.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 557 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 75 | |
| I | 46 | 8.3% |
| S | 45 | 8.1% |
| N | 42 | 7.5% |
| C | 39 | 7.0% |
| O | 37 | 6.6% |
| A | 37 | 6.6% |
| T | 34 | 6.1% |
| R | 33 | 5.9% |
| M | 30 | 5.4% |
| Other values (12) | 139 |
| Distinct | 50 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 475690 |
| Missing (%) | > 99.9% |
| Memory size | 14.5 MiB |
| INE001A01036 | 1 |
|---|---|
| INE075A01022 | 1 |
| INE019A01038 | 1 |
| INE213A01029 | 1 |
| INE481G01011 | 1 |
| Other values (45) |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 600 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 50 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | INE742F01042 |
|---|---|
| 2nd row | INE021A01026 |
| 3rd row | INE238A01034 |
| 4th row | INE917I01010 |
| 5th row | INE918I01018 |
Common Values
| Value | Count | Frequency (%) |
| INE001A01036 | 1 | < 0.1% |
| INE075A01022 | 1 | < 0.1% |
| INE019A01038 | 1 | < 0.1% |
| INE213A01029 | 1 | < 0.1% |
| INE481G01011 | 1 | < 0.1% |
| INE628A01036 | 1 | < 0.1% |
| INE216A01030 | 1 | < 0.1% |
| INE918I01018 | 1 | < 0.1% |
| INE129A01019 | 1 | < 0.1% |
| INE205A01025 | 1 | < 0.1% |
| Other values (40) | 40 | < 0.1% |
| (Missing) | 475690 |
Length
| Value | Count | Frequency (%) |
| ine752e01010 | 1 | 2.0% |
| ine239a01016 | 1 | 2.0% |
| ine062a01020 | 1 | 2.0% |
| ine237a01028 | 1 | 2.0% |
| ine522f01014 | 1 | 2.0% |
| ine021a01026 | 1 | 2.0% |
| ine213a01029 | 1 | 2.0% |
| ine075a01022 | 1 | 2.0% |
| ine917i01010 | 1 | 2.0% |
| ine154a01025 | 1 | 2.0% |
| Other values (40) | 40 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 141 | |
| 1 | 90 | |
| I | 52 | 8.7% |
| E | 52 | 8.7% |
| N | 50 | 8.3% |
| 2 | 50 | 8.3% |
| A | 38 | 6.3% |
| 6 | 20 | 3.3% |
| 3 | 20 | 3.3% |
| 8 | 18 | 3.0% |
| Other values (10) | 69 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 400 | |
| Uppercase Letter | 200 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 52 | |
| E | 52 | |
| N | 50 | |
| A | 38 | |
| F | 2 | 1.0% |
| B | 2 | 1.0% |
| D | 1 | 0.5% |
| J | 1 | 0.5% |
| C | 1 | 0.5% |
| G | 1 | 0.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 141 | |
| 1 | 90 | |
| 2 | 50 | 12.5% |
| 6 | 20 | 5.0% |
| 3 | 20 | 5.0% |
| 8 | 18 | 4.5% |
| 9 | 17 | 4.2% |
| 5 | 16 | 4.0% |
| 4 | 15 | 3.8% |
| 7 | 13 | 3.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 400 | |
| Latin | 200 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| I | 52 | |
| E | 52 | |
| N | 50 | |
| A | 38 | |
| F | 2 | 1.0% |
| B | 2 | 1.0% |
| D | 1 | 0.5% |
| J | 1 | 0.5% |
| C | 1 | 0.5% |
| G | 1 | 0.5% |
Common
| Value | Count | Frequency (%) |
| 0 | 141 | |
| 1 | 90 | |
| 2 | 50 | 12.5% |
| 6 | 20 | 5.0% |
| 3 | 20 | 5.0% |
| 8 | 18 | 4.5% |
| 9 | 17 | 4.2% |
| 5 | 16 | 4.0% |
| 4 | 15 | 3.8% |
| 7 | 13 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 600 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 141 | |
| 1 | 90 | |
| I | 52 | 8.7% |
| E | 52 | 8.7% |
| N | 50 | 8.3% |
| 2 | 50 | 8.3% |
| A | 38 | 6.3% |
| 6 | 20 | 3.3% |
| 3 | 20 | 3.3% |
| 8 | 18 | 3.0% |
| Other values (10) | 69 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | Date | Symbol | Series | Prev Close | Open | High | Low | Last | Close | VWAP | Volume | Turnover | Trades | Deliverable Volume | %Deliverble | Company Name | Industry | ISIN Code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 2000-01-03 | ZEETELE | EQ | 1092.55 | 1175.00 | 1179.95 | 1160.00 | 1179.95 | 1179.95 | 1177.03 | 1261391 | 1.484690e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 1 | 1 | 2000-01-04 | ZEETELE | EQ | 1179.95 | 1220.00 | 1274.35 | 1183.10 | 1274.35 | 1260.65 | 1228.02 | 4616547 | 5.669220e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 2 | 2 | 2000-01-05 | ZEETELE | EQ | 1260.65 | 1160.55 | 1317.70 | 1159.80 | 1190.95 | 1176.55 | 1238.35 | 8763127 | 1.085178e+15 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 3 | 3 | 2000-01-06 | ZEETELE | EQ | 1176.55 | 1195.00 | 1200.00 | 1095.00 | 1106.00 | 1115.45 | 1135.04 | 5164020 | 5.861353e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 4 | 4 | 2000-01-07 | ZEETELE | EQ | 1115.45 | 1097.10 | 1097.10 | 1026.25 | 1026.25 | 1026.25 | 1029.94 | 755129 | 7.777374e+13 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 5 | 5 | 2000-01-10 | ZEETELE | EQ | 1026.25 | 1026.25 | 1026.25 | 944.30 | 962.00 | 966.70 | 980.49 | 3942813 | 3.865885e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 6 | 6 | 2000-01-11 | ZEETELE | EQ | 966.70 | 985.00 | 1044.00 | 891.00 | 1018.80 | 1019.95 | 995.97 | 6802005 | 6.774605e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 7 | 7 | 2000-01-12 | ZEETELE | EQ | 1019.95 | 1035.00 | 1088.00 | 1035.00 | 1064.00 | 1063.85 | 1068.99 | 2968833 | 3.173653e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 8 | 8 | 2000-01-13 | ZEETELE | EQ | 1063.85 | 1073.00 | 1085.00 | 1012.70 | 1018.00 | 1023.10 | 1050.57 | 2251046 | 2.364882e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
| 9 | 9 | 2000-01-14 | ZEETELE | EQ | 1023.10 | 1030.00 | 1034.75 | 980.70 | 1001.00 | 1001.85 | 1007.74 | 2949092 | 2.971906e+14 | 62645.709283 | 1.415718e+06 | 0.452211 | NaN | NaN | NaN |
Last rows
| df_index | Date | Symbol | Series | Prev Close | Open | High | Low | Last | Close | VWAP | Volume | Turnover | Trades | Deliverable Volume | %Deliverble | Company Name | Industry | ISIN Code | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 475730 | 5296 | 2021-04-16 | ZEEL | EQ | 189.20 | 189.2 | 196.90 | 189.20 | 196.35 | 193.95 | 193.14 | 7952202 | 1.535854e+14 | 52127.0 | 1962297.0 | 0.2468 | NaN | NaN | NaN |
| 475731 | 5297 | 2021-04-19 | ZEEL | EQ | 193.95 | 187.0 | 191.20 | 185.10 | 191.00 | 190.35 | 188.28 | 9346956 | 1.759879e+14 | 58935.0 | 1270493.0 | 0.1359 | NaN | NaN | NaN |
| 475732 | 5298 | 2021-04-20 | ZEEL | EQ | 190.35 | 193.0 | 201.75 | 192.20 | 197.30 | 197.40 | 197.17 | 15709132 | 3.097437e+14 | 77021.0 | 3089894.0 | 0.1967 | NaN | NaN | NaN |
| 475733 | 5299 | 2021-04-22 | ZEEL | EQ | 197.40 | 195.5 | 199.80 | 191.70 | 192.15 | 192.30 | 194.76 | 10203121 | 1.987114e+14 | 70603.0 | 2930009.0 | 0.2872 | NaN | NaN | NaN |
| 475734 | 5300 | 2021-04-23 | ZEEL | EQ | 192.30 | 192.0 | 193.00 | 187.00 | 188.00 | 188.00 | 190.04 | 8529439 | 1.620902e+14 | 60790.0 | 2148300.0 | 0.2519 | NaN | NaN | NaN |
| 475735 | 5301 | 2021-04-26 | ZEEL | EQ | 188.00 | 190.6 | 191.10 | 185.10 | 186.70 | 186.40 | 187.35 | 8542755 | 1.600451e+14 | 52374.0 | 2340188.0 | 0.2739 | NaN | NaN | NaN |
| 475736 | 5302 | 2021-04-27 | ZEEL | EQ | 186.40 | 188.0 | 192.95 | 186.80 | 188.80 | 188.15 | 189.41 | 14247767 | 2.698636e+14 | 73673.0 | 5425957.0 | 0.3808 | NaN | NaN | NaN |
| 475737 | 5303 | 2021-04-28 | ZEEL | EQ | 188.15 | 188.8 | 190.60 | 187.10 | 188.95 | 189.10 | 188.85 | 8429439 | 1.591917e+14 | 44056.0 | 2413974.0 | 0.2864 | NaN | NaN | NaN |
| 475738 | 5304 | 2021-04-29 | ZEEL | EQ | 189.10 | 190.8 | 191.65 | 186.00 | 186.60 | 186.55 | 187.44 | 9483009 | 1.777471e+14 | 60932.0 | 2744472.0 | 0.2894 | NaN | NaN | NaN |
| 475739 | 5305 | 2021-04-30 | ZEEL | EQ | 186.55 | 185.3 | 190.95 | 183.65 | 185.00 | 185.60 | 187.53 | 11435285 | 2.144440e+14 | 62607.0 | 3323909.0 | 0.2907 | NaN | NaN | NaN |